How to: Copy a chart to a blank chart sheet.
Solution:
Create a blank chart sheet, select the chart to copy, and copy and paste the chart to the chart sheet.
1) Create a blank chart sheet:
a) Select a blank cell on a worksheet.
b) Select the 'Insert' menu and select 'Chart'. (A submenu appears.)
c) Select 'As New Sheet' from the submenu. (The ChartWizard Step 1 of 5 appears.)
d) Click 'Next ' until the ChartWizard Step 5 of 5 dialog box is displayed.
e) Click 'Finish'. (A blank chart sheet appears.)
2) Select the chart to copy.
a) If the chart is embedded on the worksheet, double-click on the chart. (A striped border with handles appears around the chart.)
b) If the chart is on a separate chart sheet, click the tab for the chart sheet.
3) Select the 'Edit' menu and select 'Copy'.
4) Click the tab for the blank chart sheet.
5) Select the 'Edit' menu and select 'Paste'.
